﻿[
    {
        title: "SBEW Head Products Manufactured (€/t)", list: "P_L", type: "Table", equ: "(({0})+({1})-({2}))/({3})*1000", fields: [
            { name: "N_1", type: "M", fields: ["PL02010102-1", "PL02010103", "Actual_VM|VM02090100&Actual", "PL02010101-1"] },
            { name: "Budget", list: "Budget_PL", type: "M", fields: ["PL03010102-1", "PL03010103", "Actual_VM|VM03090100&Actual", "PL03010101-1"] },
            { name: "Actual", type: "M", fields: ["PL02010102-1", "PL02010103", "Actual_VM|VM02090100&Actual", "PL02010101-1"] },
            { name: "A_BUD", self: true, type: "M", fields: ["Actual", "Budget"], addition: "({0})-({1})" },
            { name: "A_N_1", self: true, type: "M", fields: ["Actual", "N_1"], addition: "({0})-({1})" },
            { emptycolumn: true },
            { emptycolumn: true },
            { name: "N_1", type: "YTD", fields: ["PL02010102-1", "PL02010103", "Actual_VM|VM02090100&Actual", "PL02010101-1"] },
            { name: "Budget", list: "Budget_PL", type: "YTD", fields: ["PL03010102-1", "PL03010103", "Actual_VM|VM03090100&Actual", "PL03010101-1"] },
            { name: "Actual", type: "YTD", fields: ["PL02010102-1", "PL02010103", "Actual_VM|VM02090100&Actual", "PL02010101-1"] },
            { name: "A_BUD", self: true, type: "YTD", fields: ["Actual", "Budget"], addition: "({0})-({1})" },
            { name: "A_N_1", self: true, type: "YTD", fields: ["Actual", "N_1"], addition: "({0})-({1})" }
        ]
    }, { title: "Variable costs Head Products Manufactured €/t", list: "P_L", type: "Table", equ: "(({0})-({1}))/({2})*1000", fields: [
            { name: "N_1", type: "M", fields: ["PL02010104", "Actual_VM|VM02090100&Budget", "PL02010101-1"] },
            { name: "Budget", list: "Budget_PL", type: "M", fields: ["PL03010104", "Actual_VM|VM03090100&Budget", "PL03010101-1"] },
            { name: "Actual", type: "M", fields: ["PL02010104", "Actual_VM|VM02090100&Budget", "PL02010101-1"] },
            { name: "A_BUD", self: true, type: "M", fields: ["Actual", "Budget"], addition: "({0})-({1})" },
            { name: "A_N_1", self: true, type: "M", fields: ["Actual", "N_1"], addition: "({0})-({1})" },
            { emptycolumn: true },
            { emptycolumn: true },
            { name: "N_1", type: "YTD", fields: ["PL02010104", "Actual_VM|VM02090100&Budget", "PL02010101-1"] },
            { name: "Budget", list: "Budget_PL", type: "YTD", fields: ["PL03010104", "Actual_VM|VM03090100&Budget", "PL03010101-1"] },
            { name: "Actual", type: "YTD", fields: ["PL02010104", "Actual_VM|VM02090100&Budget", "PL02010101-1"] },
            { name: "A_BUD", self: true, type: "YTD", fields: ["Actual", "Budget"], addition: "({0})-({1})" },
            { name: "A_N_1", self: true, type: "YTD", fields: ["Actual", "N_1"], addition: "({0})-({1})" }
        ]
    },

    { title: "VM Budget", list: "Budget_PL", type: "FreeFormat", equ: "", fields: [
            { name: "Budget", type: "M", fields: ["PL03010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "Budget", type: "M", fields: ["PL03010105"] },

            { name: "Budget", type: "YTD", fields: ["PL03010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "Budget", type: "YTD", fields: ["PL03010105"] },

             { emptycolumn: true },

            { name: "", type: "", value: "MCV N-1" },
            { emptycolumn: true },
            { name: "N_1", type: "M", list: "P_L", fields: ["PL02010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "N_1", type: "M", list: "P_L", fields: ["PL02010105"] },

            { name: "N_1", type: "YTD", list: "P_L", fields: ["PL02010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "N_1", type: "YTD", list: "P_L", fields: ["PL02010105"] }
        ]
    },
    { emptyRow: true, type: "FreeFormat" },
    { title: "Volume Effect", list: "Actual_VM", type: "FreeFormat", equ: "", fields: [
            { name: "M", type: "KO", fields: ["VM02010000&Vol"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02010000&Vol"] },

            { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010000&Vol"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010000&Vol"] },

             { emptycolumn: true },

            { name: "", type: "", value: "Volume Effect" },
            { emptycolumn: true },
            { name: "M", type: "KO", fields: ["VM02020000&Vol"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02020000&Vol"] },

    { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020000&Vol"] },
            { name: "Export", type: "", value: "0" },
    { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020000&Vol"] }
        ]
    }
    ,

    { title: "Mix Effect", list: "Actual_VM", type: "FreeFormat", equ: "", fields: [
            { name: "M", type: "KO", fields: ["VM02010000&Mix"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02010000&Mix"] },

              { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010000&Mix"] },
            { name: "Export", type: "", value: "0" },
              { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010000&Mix"] },

             { emptycolumn: true },

            { name: "M", type: "", value: "Mix Effect" },
            { emptycolumn: true },
            { name: "M", type: "KO", fields: ["VM02020000&Mix"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02020000&Mix"] },

           { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020000&Mix"] },
            { name: "Export", type: "", value: "0" },
              { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020000&Mix"] }
        ]
    },

    { title: "Price Effect", list: "Actual_VM", type: "FreeFormat", equ: "({0})+({1})", fields: [
            { name: "M", type: "KO", fields: ["VM02010100&Price", "VM02010200&Price"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02010100&Price", "VM02010200&Price"] },

              { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010100&Price", "Actual_VM_YTD|VM02010200&Price"] },
            { name: "Export", type: "", value: "0" },
              { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010100&Price", "Actual_VM_YTD|VM02010200&Price"] },

             { emptycolumn: true },

            { name: "M", type: "", value: "Price Effect" },
            { emptycolumn: true },
            { name: "M", type: "KO", fields: ["VM02020100&Price", "VM02020200&Price"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02020100&Price", "VM02020200&Price"] },

    { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020100&Price", "Actual_VM_YTD|VM02020200&Price"] },
            { name: "Export", type: "", value: "0" },
    { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020100&Price", "Actual_VM_YTD|VM02020200&Price"] }
        ]
    },

    { title: "Variable Cost Effect", list: "Actual_VM", type: "FreeFormat", equ: "", fields: [
            { name: "M", type: "KO", fields: ["VM02010300&Price"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02010300&Price"] },

             { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010300&Price"] },
            { name: "Export", type: "", value: "0" },
           { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010300&Price"] },

             { emptycolumn: true },

            { name: "M", type: "", value: "Variable Cost Effect" },
            { emptycolumn: true },
            { name: "M", type: "KO", fields: ["VM02020300&Price", "VM02020300&FPP"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02020300&Price", "VM02020300&FPP"] },

            { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020300&Price", "Actual_VM_YTD|VM02020300&FPP"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020300&Price", "Actual_VM_YTD|VM02020300&FPP"] }
        ]
    },

    { emptyRow: true, type: "FreeFormat" },
    { title: "Total Variance", list: "Actual_VM", type: "FreeFormat", equ: "", fields: [
            { name: "M", type: "KO", fields: ["VM02010000&Variance"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02010000&Variance"] },

           { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010000&Variance"] },
            { name: "Export", type: "", value: "0" },
     { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02010000&Variance"] },

             { emptycolumn: true },

            { name: "M", type: "", value: "Total Variance" },
            { emptycolumn: true },
            { name: "M", type: "KO", fields: ["VM02020000&Variance"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["VM02020000&Variance"] },

           { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020000&Variance"] },
            { name: "Export", type: "", value: "0" },
            { name: "M", type: "KO", fields: ["Actual_VM_YTD|VM02020000&Variance"] }
        ]
    },

    { emptyRow: true, type: "FreeFormat" },
    { title: "VM Actual", list: "P_L", type: "FreeFormat", equ: "", fields: [

            { name: "Actual", type: "M", fields: ["PL02010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "Actual", type: "M", fields: ["PL02010105"] },

            { name: "Actual", type: "YTD", fields: ["PL02010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "Actual", type: "YTD", fields: ["PL02010105"] },

             { emptycolumn: true },

            { name: "", type: "", value: "VM Actual" },
            { emptycolumn: true },
            { name: "Actual", type: "M", fields: ["PL02010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "Actual", type: "M", fields: ["PL02010105"] },

            { name: "Actual", type: "YTD", fields: ["PL02010105"] },
            { name: "Export", type: "", value: "0" },
            { name: "Actual", type: "YTD", fields: ["PL02010105"] }

        ]
    }
] 

